<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Sorting report results</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
ul.whs2 { list-style:disc; }
ul.whs3 { list-style:square; }
ul.whs4 { list-style:circle; }
img_whs5 { border:none; width:17px; height:8px; float:none; border-style:none; }
p.whs6 { margin-left:0px; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs6 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nSorting report results");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Sorting report results</h1>
<p>You can reorganize how data is displayed on your report by sorting the 
 data. Sorting lets you move data so you can analyze your report results 
 more effectively without re-executing the report. For example, you can 
 move the most important data up to the top of the report where you can 
 see it easily. Or you can group particular sets of data together so you 
 can more easily compare related data.</p>
<p>You can sort results quickly by column or row, or you can define a more 
 complex sort pattern based on multiple rows and columns or based on objects 
 not displayed on the report. See the appropriate procedure below.</p>
<h2>To sort report results quickly</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Click the name of a grid report to execute it.</p></li>
</ol>
<ol start="2" type="1" class="whs1">
	
<li class=p><p>Do one of the following:</p></li>
</ol>
<ul type="disc" class="whs2">
	<ul type="disc" class="whs2">
		
<li class=p><p>Right-click on the column or row header to sort, 
 point to <span style="font-weight: bold;"><B>Sort</B></span>, and select either 
 <span style="font-weight: bold;"><B>Ascending</B></span> or <span style="font-weight: bold;"><B>Descending</B></span>. 
 The column or row is sorted accordingly.</p></li>
		
<li class=p><p>Use the sort buttons located within each column 
 or row header as described below. If the sort buttons are not displayed, 
 from the <span style="font-weight: bold;"><B>Tools</B></span> menu, select <span 
 style="font-weight: bold;"><B>Sort Buttons</B></span>.</p></li>
	</ul>
</ul>
<ul type="disc" class="whs2">
	<ul type="square" class="whs3">
		<ul type="circle" class="whs4">
			
<li style="list-style: square;" type=square class=p><p>A gray 
 arrow at the top of a column or row indicates that the data in the column 
 or row is unsorted. </p></li>
			<ul type="circle" class="whs4">
				
<li class=p><p>If the gray arrow is pointing up <img src="images/sort_row.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs5">, 
 click it to sort the data in that column or row in ascending order. </p></li>
				
<li class=p><p>If the gray arrow is pointing down <img src="images/sort.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs5">, 
 click it to sort the data in that column or row in descending order. </p></li>
			</ul>
			
<li style="list-style: square;" type=square class=p><p>A white 
 arrow at the top of a column or row indicates that the data in the column 
 or row is already sorted. </p></li>
			<ul type="circle" class="whs4">
				
<li class=p><p>If the white arrow is pointing up <img src="images/sort_asc.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs5">, 
 the data is already sorted in ascending order. Click it to resort in descending 
 order. </p></li>
				
<li class=p><p>If the white arrow is pointing down <img src="images/sort_desc.gif" x-maintain-ratio="TRUE" width="17px" height="8px" border="0" class="img_whs5">, 
 the data is already sorted in descending order. Click it to resort the 
 data in ascending order.</p></li>
			</ul>
		</ul>
	</ul>
</ul>
<h2>To sort report results based on multiple rows and columns</h2>
<p>You can sort based on multiple rows or columns. For example, in a report 
 that displays the profits of several stores within multiple divisions, 
 you could sort first by division, then by profit. This would allow you 
 to see the most profitable stores within their respective divisions.</p>
<p>You can sort by metrics, by custom groups, or by attribute forms, including 
 attribute forms not currently displayed on your report. For example, if 
 the Customer attribute's ID form is displayed on your report, you can 
 sort based on the DESC (description) form of the Customer attribute.</p>
<ol start="1" type="1" class="whs1">
	
<li class=p><p>Click the name of a grid report to execute it.</p></li>
</ol>
<ol start="2" type="1" class="whs1">
	
<li class=p><p class="whs6">From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Sort</B></span>. The Sort dialog 
 box is displayed. </p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs6">If 
 DHTML is disabled, click the <span style="font-weight: bold;"><B>Go</B></span> 
 icon. </p></li>
	</ul>
</ol>
<ol start="3" type="1" class="whs1">
	
<li class=p><p>The Sort dialog box/panel contains two tabs: <span style="font-weight: bold;"><B>Row</B></span> 
 and <span style="font-weight: bold;"><B>Column</B></span>. If you have not already 
 defined the sort behavior for the report, the drop-down lists in the dialog 
 box are empty. Sort using any of the following methods:<span style="font-weight: bold;"><B><br>

	&nbsp;</B></span></p></li>
</ol>
<ul type="disc" class="whs2">
	<ul type="disc" class="whs2">
		
<li class=p><p>Select the <span style="font-weight: bold;"><B>Row</B></span> 
 tab to specify sort options for the rows of your report. From the first 
 drop-down list, select the name of the first row to sort by, and whether 
 to sort it in ascending or descending order. <br>

		<br>

		For example, you have Region and Quarter attributes on the report's 
 rows. You can specify that all the region data be sorted in descending 
 order, and then that the quarters should be listed in ascending order.</p></li>
	</ul>
</ul>
<ul type="disc" class="whs2">
	<ul type="disc" class="whs2">
		
<li class=p><p>Select the <span style="font-weight: bold;"><B>Column</B></span> 
 tab to specify sort options for the columns of your report. From the first 
 drop-down list, select the name of the first column to sort by, and whether 
 to sort it in ascending or descending order. <br>

		<br>

		For example, you have Profit and Region on the report's columns. 
 You can specify that the columns be sorted by the regions in ascending 
 order.</p></li>
	</ul>
</ul>
<ol start="4" type="1" class="whs1">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>Apply</B></span> 
 to view the report with these sorting selections.</p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
